package com.teamall.web.sjtj.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class CodeVisitedOrderArg {
    private String pk_name = "family_id";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<CodeVisitedOrderCriteria> oredCriteria;

    public CodeVisitedOrderArg() {
        oredCriteria = new ArrayList<CodeVisitedOrderCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<CodeVisitedOrderCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(CodeVisitedOrderCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public CodeVisitedOrderCriteria or() {
    	CodeVisitedOrderCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public CodeVisitedOrderCriteria createCriteria() {
    	CodeVisitedOrderCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected CodeVisitedOrderCriteria createCriteriaInternal() {
    	CodeVisitedOrderCriteria criteria = new CodeVisitedOrderCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<CodeVisitedOrderCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<CodeVisitedOrderCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<CodeVisitedOrderCriterion> getAllCriteria() {
            return criteria;
        }

        public List<CodeVisitedOrderCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new CodeVisitedOrderCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedOrderCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedOrderCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedOrderCriterion(condition, value1, value2));
        }

        public CodeVisitedOrderCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andFamilyIdIsNull() {
            addCriterion("family_id is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdIsNotNull() {
            addCriterion("family_id is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdEqualTo(Integer value) {
            addCriterion("family_id =", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotEqualTo(Integer value) {
            addCriterion("family_id <>", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdGreaterThan(Integer value) {
            addCriterion("family_id >", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("family_id >=", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdLessThan(Integer value) {
            addCriterion("family_id <", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdLessThanOrEqualTo(Integer value) {
            addCriterion("family_id <=", value, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdLike(Integer value) {
            addCriterion("family_id like ", value, "family_id", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotLike(Integer value) {
            addCriterion("family_id  not like ", value, "family_id", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdLeftLike(Integer value) {
            addCriterion("family_id like ", value, "family_id", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotLeftLike(Integer value) {
            addCriterion("family_id  not like ", value, "family_id", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdRightLike(Integer value) {
            addCriterion("family_id like ", value, "family_id", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotRightLike(Integer value) {
            addCriterion("family_id  not like ", value, "family_id", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdIn(List<Integer> values) {
            addCriterion("family_id  in ", values, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotIn(List<Integer> values) {
            addCriterion("family_id not in ", values, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdBetween(Integer value1, Integer value2) {
            addCriterion("family_id between ", value1, value2, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andFamilyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("family_id not between ", value1, value2, "family_id");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andAidMainStaffIsNull() {
            addCriterion("aid_main_staff is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffIsNotNull() {
            addCriterion("aid_main_staff is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffEqualTo(Integer value) {
            addCriterion("aid_main_staff =", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotEqualTo(Integer value) {
            addCriterion("aid_main_staff <>", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffGreaterThan(Integer value) {
            addCriterion("aid_main_staff >", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffGreaterThanOrEqualTo(Integer value) {
            addCriterion("aid_main_staff >=", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffLessThan(Integer value) {
            addCriterion("aid_main_staff <", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffLessThanOrEqualTo(Integer value) {
            addCriterion("aid_main_staff <=", value, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffLike(Integer value) {
            addCriterion("aid_main_staff like ", value, "aid_main_staff", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotLike(Integer value) {
            addCriterion("aid_main_staff  not like ", value, "aid_main_staff", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffLeftLike(Integer value) {
            addCriterion("aid_main_staff like ", value, "aid_main_staff", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotLeftLike(Integer value) {
            addCriterion("aid_main_staff  not like ", value, "aid_main_staff", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffRightLike(Integer value) {
            addCriterion("aid_main_staff like ", value, "aid_main_staff", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotRightLike(Integer value) {
            addCriterion("aid_main_staff  not like ", value, "aid_main_staff", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffIn(List<Integer> values) {
            addCriterion("aid_main_staff  in ", values, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotIn(List<Integer> values) {
            addCriterion("aid_main_staff not in ", values, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffBetween(Integer value1, Integer value2) {
            addCriterion("aid_main_staff between ", value1, value2, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andAidMainStaffNotBetween(Integer value1, Integer value2) {
            addCriterion("aid_main_staff not between ", value1, value2, "aid_main_staff");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andStaffNameIsNull() {
            addCriterion("STAFF_NAME is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameIsNotNull() {
            addCriterion("STAFF_NAME is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameEqualTo(String value) {
            addCriterion("STAFF_NAME =", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotEqualTo(String value) {
            addCriterion("STAFF_NAME <>", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameGreaterThan(String value) {
            addCriterion("STAFF_NAME >", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("STAFF_NAME >=", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameLessThan(String value) {
            addCriterion("STAFF_NAME <", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("STAFF_NAME <=", value, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameLike(String value) {
            addCriterion("STAFF_NAME like ", value, "STAFF_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotLike(String value) {
            addCriterion("STAFF_NAME  not like ", value, "STAFF_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameLeftLike(String value) {
            addCriterion("STAFF_NAME like ", value, "STAFF_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotLeftLike(String value) {
            addCriterion("STAFF_NAME  not like ", value, "STAFF_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameRightLike(String value) {
            addCriterion("STAFF_NAME like ", value, "STAFF_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotRightLike(String value) {
            addCriterion("STAFF_NAME  not like ", value, "STAFF_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameIn(List<String> values) {
            addCriterion("STAFF_NAME  in ", values, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotIn(List<String> values) {
            addCriterion("STAFF_NAME not in ", values, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameBetween(String value1, String value2) {
            addCriterion("STAFF_NAME between ", value1, value2, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("STAFF_NAME not between ", value1, value2, "STAFF_NAME");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andVisitedCountIsNull() {
            addCriterion("VISITED_COUNT is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountIsNotNull() {
            addCriterion("VISITED_COUNT is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountEqualTo(BigDecimal value) {
            addCriterion("VISITED_COUNT =", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotEqualTo(BigDecimal value) {
            addCriterion("VISITED_COUNT <>", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountGreaterThan(BigDecimal value) {
            addCriterion("VISITED_COUNT >", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VISITED_COUNT >=", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountLessThan(BigDecimal value) {
            addCriterion("VISITED_COUNT <", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VISITED_COUNT <=", value, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountLike(BigDecimal value) {
            addCriterion("VISITED_COUNT like ", value, "VISITED_COUNT", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotLike(BigDecimal value) {
            addCriterion("VISITED_COUNT  not like ", value, "VISITED_COUNT", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountLeftLike(BigDecimal value) {
            addCriterion("VISITED_COUNT like ", value, "VISITED_COUNT", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotLeftLike(BigDecimal value) {
            addCriterion("VISITED_COUNT  not like ", value, "VISITED_COUNT", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountRightLike(BigDecimal value) {
            addCriterion("VISITED_COUNT like ", value, "VISITED_COUNT", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotRightLike(BigDecimal value) {
            addCriterion("VISITED_COUNT  not like ", value, "VISITED_COUNT", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountIn(List<BigDecimal> values) {
            addCriterion("VISITED_COUNT  in ", values, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotIn(List<BigDecimal> values) {
            addCriterion("VISITED_COUNT not in ", values, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VISITED_COUNT between ", value1, value2, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVisitedCountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VISITED_COUNT not between ", value1, value2, "VISITED_COUNT");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andVillageIdIsNull() {
            addCriterion("VILLAGE_ID is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdIsNotNull() {
            addCriterion("VILLAGE_ID is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdEqualTo(Integer value) {
            addCriterion("VILLAGE_ID =", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotEqualTo(Integer value) {
            addCriterion("VILLAGE_ID <>", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdGreaterThan(Integer value) {
            addCriterion("VILLAGE_ID >", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("VILLAGE_ID >=", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdLessThan(Integer value) {
            addCriterion("VILLAGE_ID <", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdLessThanOrEqualTo(Integer value) {
            addCriterion("VILLAGE_ID <=", value, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdLeftLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotLeftLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdRightLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotRightLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdIn(List<Integer> values) {
            addCriterion("VILLAGE_ID  in ", values, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotIn(List<Integer> values) {
            addCriterion("VILLAGE_ID not in ", values, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdBetween(Integer value1, Integer value2) {
            addCriterion("VILLAGE_ID between ", value1, value2, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageIdNotBetween(Integer value1, Integer value2) {
            addCriterion("VILLAGE_ID not between ", value1, value2, "VILLAGE_ID");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andVillageNameIsNull() {
            addCriterion("VILLAGE_NAME is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameIsNotNull() {
            addCriterion("VILLAGE_NAME is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameEqualTo(String value) {
            addCriterion("VILLAGE_NAME =", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotEqualTo(String value) {
            addCriterion("VILLAGE_NAME <>", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameGreaterThan(String value) {
            addCriterion("VILLAGE_NAME >", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameGreaterThanOrEqualTo(String value) {
            addCriterion("VILLAGE_NAME >=", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameLessThan(String value) {
            addCriterion("VILLAGE_NAME <", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameLessThanOrEqualTo(String value) {
            addCriterion("VILLAGE_NAME <=", value, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameLeftLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotLeftLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameRightLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotRightLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameIn(List<String> values) {
            addCriterion("VILLAGE_NAME  in ", values, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotIn(List<String> values) {
            addCriterion("VILLAGE_NAME not in ", values, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameBetween(String value1, String value2) {
            addCriterion("VILLAGE_NAME between ", value1, value2, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVillageNameNotBetween(String value1, String value2) {
            addCriterion("VILLAGE_NAME not between ", value1, value2, "VILLAGE_NAME");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andTownIdIsNull() {
            addCriterion("TOWN_ID is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdIsNotNull() {
            addCriterion("TOWN_ID is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdEqualTo(Integer value) {
            addCriterion("TOWN_ID =", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotEqualTo(Integer value) {
            addCriterion("TOWN_ID <>", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdGreaterThan(Integer value) {
            addCriterion("TOWN_ID >", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TOWN_ID >=", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdLessThan(Integer value) {
            addCriterion("TOWN_ID <", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdLessThanOrEqualTo(Integer value) {
            addCriterion("TOWN_ID <=", value, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdLeftLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotLeftLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdRightLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotRightLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdIn(List<Integer> values) {
            addCriterion("TOWN_ID  in ", values, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotIn(List<Integer> values) {
            addCriterion("TOWN_ID not in ", values, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdBetween(Integer value1, Integer value2) {
            addCriterion("TOWN_ID between ", value1, value2, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TOWN_ID not between ", value1, value2, "TOWN_ID");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andTownNameIsNull() {
            addCriterion("TOWN_NAME is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameIsNotNull() {
            addCriterion("TOWN_NAME is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameEqualTo(String value) {
            addCriterion("TOWN_NAME =", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotEqualTo(String value) {
            addCriterion("TOWN_NAME <>", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameGreaterThan(String value) {
            addCriterion("TOWN_NAME >", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameGreaterThanOrEqualTo(String value) {
            addCriterion("TOWN_NAME >=", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameLessThan(String value) {
            addCriterion("TOWN_NAME <", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameLessThanOrEqualTo(String value) {
            addCriterion("TOWN_NAME <=", value, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameLeftLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotLeftLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameRightLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotRightLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameIn(List<String> values) {
            addCriterion("TOWN_NAME  in ", values, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotIn(List<String> values) {
            addCriterion("TOWN_NAME not in ", values, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameBetween(String value1, String value2) {
            addCriterion("TOWN_NAME between ", value1, value2, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andTownNameNotBetween(String value1, String value2) {
            addCriterion("TOWN_NAME not between ", value1, value2, "TOWN_NAME");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andDepartmentIsNull() {
            addCriterion("DEPARTMENT is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentIsNotNull() {
            addCriterion("DEPARTMENT is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentEqualTo(String value) {
            addCriterion("DEPARTMENT =", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotEqualTo(String value) {
            addCriterion("DEPARTMENT <>", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentGreaterThan(String value) {
            addCriterion("DEPARTMENT >", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("DEPARTMENT >=", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentLessThan(String value) {
            addCriterion("DEPARTMENT <", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentLessThanOrEqualTo(String value) {
            addCriterion("DEPARTMENT <=", value, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentLike(String value) {
            addCriterion("DEPARTMENT like ", value, "DEPARTMENT", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotLike(String value) {
            addCriterion("DEPARTMENT  not like ", value, "DEPARTMENT", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentLeftLike(String value) {
            addCriterion("DEPARTMENT like ", value, "DEPARTMENT", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotLeftLike(String value) {
            addCriterion("DEPARTMENT  not like ", value, "DEPARTMENT", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentRightLike(String value) {
            addCriterion("DEPARTMENT like ", value, "DEPARTMENT", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotRightLike(String value) {
            addCriterion("DEPARTMENT  not like ", value, "DEPARTMENT", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentIn(List<String> values) {
            addCriterion("DEPARTMENT  in ", values, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotIn(List<String> values) {
            addCriterion("DEPARTMENT not in ", values, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentBetween(String value1, String value2) {
            addCriterion("DEPARTMENT between ", value1, value2, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andDepartmentNotBetween(String value1, String value2) {
            addCriterion("DEPARTMENT not between ", value1, value2, "DEPARTMENT");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andVtimeIsNull() {
            addCriterion("vtime is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeIsNotNull() {
            addCriterion("vtime is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeEqualTo(String value) {
            addCriterion("vtime =", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotEqualTo(String value) {
            addCriterion("vtime <>", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeGreaterThan(String value) {
            addCriterion("vtime >", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeGreaterThanOrEqualTo(String value) {
            addCriterion("vtime >=", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeLessThan(String value) {
            addCriterion("vtime <", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeLessThanOrEqualTo(String value) {
            addCriterion("vtime <=", value, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeLike(String value) {
            addCriterion("vtime like ", value, "vtime", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeLeftLike(String value) {
            addCriterion("vtime like ", value, "vtime", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotLeftLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeRightLike(String value) {
            addCriterion("vtime like ", value, "vtime", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotRightLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeIn(List<String> values) {
            addCriterion("vtime  in ", values, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotIn(List<String> values) {
            addCriterion("vtime not in ", values, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeBetween(String value1, String value2) {
            addCriterion("vtime between ", value1, value2, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVtimeNotBetween(String value1, String value2) {
            addCriterion("vtime not between ", value1, value2, "vtime");
            return (CodeVisitedOrderCriteria) this;
        }
        public CodeVisitedOrderCriteria andVmonthIsNull() {
            addCriterion("vmonth is null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthIsNotNull() {
            addCriterion("vmonth is not null");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthEqualTo(String value) {
            addCriterion("vmonth =", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotEqualTo(String value) {
            addCriterion("vmonth <>", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthGreaterThan(String value) {
            addCriterion("vmonth >", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthGreaterThanOrEqualTo(String value) {
            addCriterion("vmonth >=", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthLessThan(String value) {
            addCriterion("vmonth <", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthLessThanOrEqualTo(String value) {
            addCriterion("vmonth <=", value, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthLike(String value) {
            addCriterion("vmonth like ", value, "vmonth", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotLike(String value) {
            addCriterion("vmonth  not like ", value, "vmonth", 1);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthLeftLike(String value) {
            addCriterion("vmonth like ", value, "vmonth", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotLeftLike(String value) {
            addCriterion("vmonth  not like ", value, "vmonth", 0);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthRightLike(String value) {
            addCriterion("vmonth like ", value, "vmonth", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotRightLike(String value) {
            addCriterion("vmonth  not like ", value, "vmonth", 2);
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthIn(List<String> values) {
            addCriterion("vmonth  in ", values, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotIn(List<String> values) {
            addCriterion("vmonth not in ", values, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthBetween(String value1, String value2) {
            addCriterion("vmonth between ", value1, value2, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

        public CodeVisitedOrderCriteria andVmonthNotBetween(String value1, String value2) {
            addCriterion("vmonth not between ", value1, value2, "vmonth");
            return (CodeVisitedOrderCriteria) this;
        }

    }

    public static class CodeVisitedOrderCriteria extends GeneratedCriteria {

        protected CodeVisitedOrderCriteria() {
            super();
        }
    }

    public static class CodeVisitedOrderCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected CodeVisitedOrderCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected CodeVisitedOrderCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected CodeVisitedOrderCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected CodeVisitedOrderCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected CodeVisitedOrderCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected CodeVisitedOrderCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}